using System;
using System.Collections.Generic;
using System.Text;
using EntityLayer;
using DataAccessLayer;
using System.Data;

namespace DataLayer
{
    public class datQuerystrings
    {
        public datQuerystrings()
        {
        }

        #region  Code Factory Generated Methods
        public void InsertQuerystrings(entQuerystrings parEntQuerystrings, DbConnector parDbConnector)
        {
            DbParamCollection insDbParamCollection = new DbParamCollection();
            insDbParamCollection.Add("@pGuid", parEntQuerystrings.Guid.ToString());
            insDbParamCollection.Add("@pQuerystring", parEntQuerystrings.Querystring);
            insDbParamCollection.AddOutput("@pQuerystringId", DbType.Int32);
            parDbConnector.ExecuteNonQuery("InsertQuerystrings", insDbParamCollection);
            parEntQuerystrings.QuerystringId = Convert.ToInt32(insDbParamCollection.GetOutPutParameter().Value);
        }
        public DataTable SelectQuerystrings(DbConnector parDbConnector)
        {

            return parDbConnector.ExecuteDataTable("SelectQuerystrings", null);
        }
        #endregion
    }
}
